NOTE: PROCEDURE PRINTTO used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              21.87k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:24 AM
      Step Count                        1369  Switch Count  0
      

4648  proc datasets library=work kill;
NOTE: Writing HTML Body file: sashtml37.htm
NOTE: Deleting WORK.SAMPLE (memtype=DATA).
NOTE: Deleting WORK.SAMPLELEADLAG (memtype=DATA).
NOTE: Deleting WORK.SASMAC3 (memtype=CATALOG).
NOTE: Deleting WORK.SASMACR (memtype=CATALOG).
NOTE: File WORK.SASMACR (memtype=CATALOG) cannot be deleted because it is in use.
4649  
4650  ods html close; /* close previous */
4651  ods html; /* open new */
NOTE: Writing HTML Body file: sashtml38.htm
4652  
4653  libname turkey '...';
NOTE: Libref TURKEY was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: '...'
4654  
4655  
4656  options ls = 200 ps=max nocenter nodate fullstimer;
4657  title ' ';
4658  
4659  options source;
4660  
4661  
4662  /* MERGING RAW DATA FILES
4663  
4664  This code merges together raw data collected from a variety of sources referred to in the data data disclosure policy.
4665  Each raw data file is imported and merged into the sample and then any changes to the data are also documented
4666  */
4667  
4668  /*Many of the raw data files were collected in a manner where each row represented a company and each column ayear.
4669  The following macro reformats the raw data set to have each row represent a single 'ticker-year';
4670  */
4671  
4672  %let filepath = ...;
4673  
4674  %macro process_and_merge(datafile, outdata, varname);
4675      /* Import Data */
4676      proc import datafile="&filepath\&datafile..xlsx"
4677          out=temp dbms=xlsx replace;
4678          getnames = yes;
4679      run;
4680  
4681      /* Transpose Data */
4682      proc transpose data=work.temp out=work.long(rename=(col1=Value));
4683          by Ticker;
4684      run;
4685  
4686      /* Create Final Dataset */
4687      data work.final;
4688          set work.long;
4689          Year = _LABEL_ * 1;
4690          drop _NAME_ _LABEL_;
4691      run;
4692  
4693      /* Rename */
4694      data &outdata;
4695          set final;
4696          rename Value = &varname;
4697  
4698  run;
4699  
4700  
4701      /* Merge with Sample */
4702      proc sql;
4703          create table sample as select a.*, b.&varname
4704          from sample as a left outer join &outdata as b
4705          on a.Ticker = b.Ticker and a.Year = b.Year;
4706      quit;
4707  %mend;
4708  
4709  
4710  *industry codes;

NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.45 seconds
      user cpu time       0.09 seconds
      system cpu time     0.03 seconds
      memory              6435.56k
      OS Memory           24316.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1370  Switch Count  0
      

4711  proc import datafile="&filepath\SectorCodes_A.xlsx"
4712      out=temp
4713      dbms=xlsx
4714      replace;
4715      getnames = yes;
4716  Run;

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.10 seconds
      user cpu time       0.07 seconds
      system cpu time     0.03 seconds
      memory              3212.87k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1371  Switch Count  0
      

4717  
4718  proc transpose data=work.temp out=work.long(rename=(col1=Value));
4719  by Ticker;
4720  
4721  run;

NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1372  Switch Count  0
      

4722  
4723  data work.final;
4724  set work.long;
4725  Year = _LABEL_ * 1;
4726  drop _NAME_ _LABEL_;
4727  
4728  run;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      4725:8   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1373  Switch Count  0
      

4729  
4730  data industrycodes; set final;
4731  rename Value = Industry;
4732  
4733  run;

NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.INDUSTRYCODES has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1374  Switch Count  0
      

4734  
4735  data sample; set industrycodes;
4736  
4737  /* Call the macro for each dataset */
4738  %process_and_merge(IndexConstituentIssuerTickers_A, indexconst, XU100);

NOTE: There were 10200 observations read from the data set WORK.INDUSTRYCODES.
NOTE: The data set WORK.SAMPLE has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              634.59k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1375  Switch Count  0
      


NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      user cpu time       0.04 seconds
      system cpu time     0.00 seconds
      memory              3213.90k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1376  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1377  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1378  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.INDEXCONST has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1379  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 4 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5660.31k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1380  Switch Count  0
      

4739  %process_and_merge(BsA_A, assets, assets);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.04 seconds
      system cpu time     0.00 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1381  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1382  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1383  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.ASSETS has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1384  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 5 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.02 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5661.90k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1385  Switch Count  0
      

4740  %process_and_merge(BsSe_A, equity, equity);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.07 seconds
      user cpu time       0.06 seconds
      system cpu time     0.01 seconds
      memory              3213.90k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1386  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1387  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1388  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.EQUITY has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1389  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 6 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5663.31k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1390  Switch Count  0
      

4741  %process_and_merge(IsGmS_A, booksales, booksales);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.04 seconds
      system cpu time     0.01 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1391  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1392  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1393  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKSALES has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:25 AM
      Step Count                        1394  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 7 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5663.12k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1395  Switch Count  0
      

4742  %process_and_merge(IsGm_A, bookgp, bookgp);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.04 seconds
      system cpu time     0.01 seconds
      memory              3215.21k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1396  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1397  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1398  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKGP has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1399  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5664.90k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1400  Switch Count  0
      

4743  %process_and_merge(IsOI_A, bookoi, bookoi);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.06 seconds
      system cpu time     0.00 seconds
      memory              3216.90k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1401  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1402  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1403  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKOI has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1404  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 9 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              5665.09k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1405  Switch Count  0
      

4744  %process_and_merge(IsNiPTI_A, bookPTI, bookPTI);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.05 seconds
      user cpu time       0.04 seconds
      system cpu time     0.01 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1406  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1407  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1408  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKPTI has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1409  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 10 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5665.09k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1410  Switch Count  0
      

4745  %process_and_merge(IsNi_A, bookNI, bookNI);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.07 seconds
      user cpu time       0.03 seconds
      system cpu time     0.03 seconds
      memory              3212.87k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1411  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1412  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1413  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKNI has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1414  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 11 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5667.90k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1415  Switch Count  0
      

4746  %process_and_merge(CsOc_A, CFO, CFO);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.05 seconds
      user cpu time       0.03 seconds
      system cpu time     0.03 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1416  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.02 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1417  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1418  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.CFO has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1419  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 12 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5668.09k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1420  Switch Count  0
      

4747  %process_and_merge(TsOi_A, taxOI, taxOI);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.03 seconds
      user cpu time       0.00 seconds
      system cpu time     0.03 seconds
      memory              3223.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1421  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2545.62k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1422  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1423  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXOI has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1424  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 13 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              5668.90k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1425  Switch Count  0
      

4748  %process_and_merge(TsNiPti_A, taxPTI, taxPTI);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      user cpu time       0.00 seconds
      system cpu time     0.03 seconds
      memory              3218.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1426  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2546.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1427  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1428  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXPTI has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1429  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 14 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.02 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5717.25k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1430  Switch Count  0
      

4749  %process_and_merge(TsNi_A, taxNI, taxNI);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      user cpu time       0.01 seconds
      system cpu time     0.01 seconds
      memory              3223.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1431  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2545.62k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1432  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1433  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXNI has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1434  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 15 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              5717.62k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1435  Switch Count  0
      

4750  %process_and_merge(TsGmS_A, taxSALES, taxSALES);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      user cpu time       0.03 seconds
      system cpu time     0.03 seconds
      memory              3218.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1436  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              2546.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1437  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1438  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXSALES has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1439  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 16 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5717.81k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1440  Switch Count  0
      

4751  %process_and_merge(TsGm_A, taxGP, taxGP);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.03 seconds
      user cpu time       0.04 seconds
      system cpu time     0.00 seconds
      memory              3223.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:26 AM
      Step Count                        1441  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2545.62k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1442  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1443  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXGP has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1444  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 17 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5719.40k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1445  Switch Count  0
      

4752  %process_and_merge(IsNiItd_A, bookTXD, bookTXD);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.03 seconds
      user cpu time       0.04 seconds
      system cpu time     0.00 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1446  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              2620.93k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1447  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1448  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKTXD has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1449  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 18 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5719.59k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1450  Switch Count  0
      

4753  %process_and_merge(IsNiItc_A, bookTXC, bookTXC);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.05 seconds
      user cpu time       0.01 seconds
      system cpu time     0.03 seconds
      memory              3212.25k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1451  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1452  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1453  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKTXC has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1454  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 19 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5719.43k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1455  Switch Count  0
      

4754  %process_and_merge(IsNiIt_A, bookTXT, bookTXT);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.03 seconds
      system cpu time     0.03 seconds
      memory              3215.21k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1456  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1457  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1458  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.BOOKTXT has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1459  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 20 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              5722.21k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1460  Switch Count  0
      

4755  %process_and_merge(FiscalQuarterEndMc_A, marketcap, marketcap);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.06 seconds
      user cpu time       0.03 seconds
      system cpu time     0.01 seconds
      memory              3212.87k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1461  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1462  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1463  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.MARKETCAP has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1464  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 21 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5722.40k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1465  Switch Count  0
      

4756  %process_and_merge(NumberOfDays_A, numdays, numdays);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      user cpu time       0.03 seconds
      system cpu time     0.00 seconds
      memory              3219.90k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1466  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 6600 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              2546.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1467  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 6600 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.06k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1468  Switch Count  0
      


NOTE: There were 6600 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.NUMDAYS has 6600 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              626.34k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1469  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 22 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              5722.59k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1470  Switch Count  0
      

4757  %process_and_merge(TaxRates_A, taxrate, taxrate);

NOTE:    Variable Name Change.  2003 -> _2003                           
NOTE:    Variable Name Change.  2004 -> _2004                           
NOTE:    Variable Name Change.  2005 -> _2005                           
NOTE:    Variable Name Change.  2006 -> _2006                           
NOTE:    Variable Name Change.  2007 -> _2007                           
NOTE:    Variable Name Change.  2008 -> _2008                           
NOTE:    Variable Name Change.  2009 -> _2009                           
NOTE:    Variable Name Change.  2010 -> _2010                           
NOTE:    Variable Name Change.  2011 -> _2011                           
NOTE:    Variable Name Change.  2012 -> _2012                           
NOTE:    Variable Name Change.  2013 -> _2013                           
NOTE:    Variable Name Change.  2014 -> _2014                           
NOTE:    Variable Name Change.  2015 -> _2015                           
NOTE:    Variable Name Change.  2016 -> _2016                           
NOTE:    Variable Name Change.  2017 -> _2017                           
NOTE:    Variable Name Change.  2018 -> _2018                           
NOTE:    Variable Name Change.  2019 -> _2019                           
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 600 observations and 18 variables.
NOTE: WORK.TEMP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.09 seconds
      user cpu time       0.07 seconds
      system cpu time     0.01 seconds
      memory              3212.87k
      OS Memory           26440.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1471  Switch Count  0
      


NOTE: There were 600 observations read from the data set WORK.TEMP.
NOTE: The data set WORK.LONG has 10200 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              2625.03k
      OS Memory           26108.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1472  Switch Count  0
      


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      2:52   
NOTE: There were 10200 observations read from the data set WORK.LONG.
NOTE: The data set WORK.FINAL has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              632.93k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1473  Switch Count  0
      


NOTE: There were 10200 observations read from the data set WORK.FINAL.
NOTE: The data set WORK.TAXRATE has 10200 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              628.00k
      OS Memory           24056.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1474  Switch Count  0
      

WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 23 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5724.40k
      OS Memory           29180.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1475  Switch Count  0
      

4758  
4759  run;
4760  
4761  *the following data are organized with ticker as the row and each column a day. The mege pulls in the data relevant to the date referenced;
4762  
4763  * Bring in book Book event prices;
4764  
4765    proc sql;
4766          create table sample as select a.*, b.BookReportDate, b.PF, b.pfdate, b.thirdqtrdate
4767          from sample as a left outer join turkey.bookpricesfinal as b
4768          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 27 columns.

4769      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.01 seconds
      memory              19108.87k
      OS Memory           41188.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1476  Switch Count  0
      

4770  
4771  run;
4772  
4773  *bring in price on fiscal year end date;
4774    proc sql;
4775          create table sample as select a.*, b.BookReportDate, b.P0, b.p0date
4776          from sample as a left outer join turkey.bookpricesfinal as b
4777          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
WARNING: Variable BooKReportDate already exists on file WORK.SAMPLE.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 29 columns.

4778      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.01 seconds
      memory              16390.12k
      OS Memory           38460.00k
      Timestamp           08/25/2026 09:44:27 AM
      Step Count                        1477  Switch Count  0
      

4779  
4780  run;
4781  
4782  
4783  *bring in market cap on book announcement date;
4784  proc import datafile="&filepath\BookEventMC.xlsx"
4785      out=BookMC
4786      dbms=xlsx
4787      replace;
4788      getnames = yes;
4789  Run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 29677 observations and 805 variables.
NOTE: WORK.BOOKMC data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           3:05.58
      user cpu time       3:04.32
      system cpu time     0.51 seconds
      memory              6255.06k
      OS Memory           29000.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1478  Switch Count  0
      

4790  
4791  data bookMC; set bookMC;
4792  if quarter ne 4 then delete;
4793  
4794  *rename colimn to market cap on book announcement date;

NOTE: There were 29677 observations read from the data set WORK.BOOKMC.
NOTE: The data set WORK.BOOKMC has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.25 seconds
      user cpu time       0.09 seconds
      system cpu time     0.10 seconds
      memory              2774.62k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1479  Switch Count  0
      

4795  data bookMC; set bookMC;
4796  rename D401 = PFMC;
4797  

NOTE: There were 7754 observations read from the data set WORK.BOOKMC.
NOTE: The data set WORK.BOOKMC has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      user cpu time       0.01 seconds
      system cpu time     0.06 seconds
      memory              2772.37k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1480  Switch Count  0
      

4798  data bookMC; set bookMC;
4799  label PFMC = 'PFMC';
4800  

NOTE: There were 7754 observations read from the data set WORK.BOOKMC.
NOTE: The data set WORK.BOOKMC has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      user cpu time       0.00 seconds
      system cpu time     0.07 seconds
      memory              2772.37k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1481  Switch Count  0
      

4801  data bookmc1; set bookmc;
4802  keep Ticker Quarter Year BooKReportDate PFMC;
4803  

NOTE: There were 7754 observations read from the data set WORK.BOOKMC.
NOTE: The data set WORK.BOOKMC1 has 7754 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      user cpu time       0.01 seconds
      system cpu time     0.04 seconds
      memory              2004.71k
      OS Memory           25080.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1482  Switch Count  0
      

4804  data turkey.bookmc; set bookmc1;
4805  
4806  run;

NOTE: There were 7754 observations read from the data set WORK.BOOKMC1.
NOTE: The data set TURKEY.BOOKMC has 7754 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              633.43k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1483  Switch Count  0
      

4807  
4808  
4809  data bookmc; set turkey.bookmc;

NOTE: There were 7754 observations read from the data set TURKEY.BOOKMC.
NOTE: The data set WORK.BOOKMC has 7754 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              633.56k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1484  Switch Count  0
      

4810    proc sql;
4811          create table sample as select a.*, b.PFMC
4812          from sample as a left outer join bookmc as b
4813          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 11327 rows and 30 columns.

4814      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5731.65k
      OS Memory           29436.00k
      Timestamp           08/25/2026 09:47:33 AM
      Step Count                        1485  Switch Count  0
      

4815  
4816  run;
4817  
4818  
4819  *Bring in the unadjusted bookreport date;
4820  
4821    proc sql;
4822          create table sample as select a.*, b.BookReportTime
4823          from sample as a left outer join turkey.booktime as b
4824          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 17199 rows and 31 columns.

4825      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.15 seconds
      user cpu time       0.03 seconds
      system cpu time     0.00 seconds
      memory              15061.84k
      OS Memory           37348.00k
      Timestamp           08/25/2026 09:47:34 AM
      Step Count                        1486  Switch Count  0
      

4826  
4827  run;
4828  
4829  *Bring in the Tax Report Dates and unadjusted date and time date;
4830  
4831    proc sql;
4832          create table sample as select a.*, b.TaxReportDate, b.TaxReportDateTime
4833          from sample as a left outer join turkey.taxtime as b
4834          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 17199 rows and 33 columns.

4835      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5735.90k
      OS Memory           29436.00k
      Timestamp           08/25/2026 09:47:34 AM
      Step Count                        1487  Switch Count  0
      

4836  
4837  run;
4838  
4839  *calculate shares outstanding;
4840  data sample; set sample;
4841  PFshares = PFMC/PF;
4842  
4843  run;

NOTE: Missing values were generated as a result of performing an operation on missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      4990 at 4841:16   
NOTE: There were 17199 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 17199 observations and 34 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              728.28k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:47:34 AM
      Step Count                        1488  Switch Count  0
      

4844  
4845  proc sort data = sample nodupkey; by ticker year;
4846  
4847  run;

NOTE: There were 17199 observations read from the data set WORK.SAMPLE.
NOTE: 6999 observations with duplicate key values were deleted.
NOTE: The data set WORK.SAMPLE has 10200 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              7366.96k
      OS Memory           31004.00k
      Timestamp           08/25/2026 09:47:34 AM
      Step Count                        1489  Switch Count  0
      

4848  
4849  *bring in tax report date market cap;
4850  
4851  *bring in market cap on tax announcement date;
4852  proc import datafile="&filepath\TaxEventMC.xlsx"
4853      out=TaxMC
4854      dbms=xlsx
4855      replace;
4856      getnames = yes;
4857  Run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 7200 observations and 406 variables.
NOTE: WORK.TAXMC data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           23.06 seconds
      user cpu time       22.87 seconds
      system cpu time     0.14 seconds
      memory              4775.50k
      OS Memory           27468.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1490  Switch Count  0
      

4858  
4859  data taxMC; set taxMC;
4860  if QtrNumber ne 4 then delete;
4861  
4862  *rename market cap on tax date;

NOTE: There were 7200 observations read from the data set WORK.TAXMC.
NOTE: The data set WORK.TAXMC has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              1953.50k
      OS Memory           25600.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1491  Switch Count  0
      

4863  data taxMC; set taxMC;
4864  rename D401 = taxMC;
4865  

NOTE: There were 3326 observations read from the data set WORK.TAXMC.
NOTE: The data set WORK.TAXMC has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              1951.46k
      OS Memory           25600.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1492  Switch Count  0
      

4866  data taxMC; set taxMC;
4867  label taxMC = 'taxMC';
4868  

NOTE: There were 3326 observations read from the data set WORK.TAXMC.
NOTE: The data set WORK.TAXMC has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              1951.50k
      OS Memory           25600.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1493  Switch Count  0
      

4869  data taxMC1; set taxMC;
4870  keep Ticker     Year TaxReportDate taxMC;
4871  

NOTE: There were 3326 observations read from the data set WORK.TAXMC.
NOTE: The data set WORK.TAXMC1 has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              1364.25k
      OS Memory           25084.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1494  Switch Count  0
      

4872  data turkey.taxmc; set taxmc1;
4873  
4874  

NOTE: There were 3326 observations read from the data set WORK.TAXMC1.
NOTE: The data set TURKEY.TAXMC has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              631.50k
      OS Memory           24568.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1495  Switch Count  0
      

4875  data taxmc; set turkey.taxmc;

NOTE: There were 3326 observations read from the data set TURKEY.TAXMC.
NOTE: The data set WORK.TAXMC has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              631.62k
      OS Memory           24568.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1496  Switch Count  0
      

4876    proc sql;
4877          create table sample as select a.*, b.taxMC
4878          from sample as a left outer join taxmc as b
4879          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 35 columns.

4880      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5735.43k
      OS Memory           29692.00k
      Timestamp           08/25/2026 09:47:57 AM
      Step Count                        1497  Switch Count  0
      

4881  
4882  run;
4883  
4884  
4885  * bring in tax date market adjusted returns;
4886  proc import datafile="&filepath\TaxEventMarketAdjRet.xlsx"
4887      out=TaxAdjRet
4888      dbms=xlsx
4889      replace;
4890      getnames = yes;
4891  Run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 7200 observations and 406 variables.
NOTE: WORK.TAXADJRET data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           24.34 seconds
      user cpu time       24.09 seconds
      system cpu time     0.14 seconds
      memory              4763.65k
      OS Memory           27468.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1498  Switch Count  0
      

4892  
4893  data TaxAdjRet; set TaxAdjRet;
4894  if QtrNumber ne 4 then delete;
4895  
4896  

NOTE: There were 7200 observations read from the data set WORK.TAXADJRET.
NOTE: The data set WORK.TAXADJRET has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              1953.06k
      OS Memory           25600.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1499  Switch Count  0
      

4897  data TaxAdjRet; set TaxAdjRet;
4898  rename D401 = TaxAdjRet;
4899  

NOTE: There were 3326 observations read from the data set WORK.TAXADJRET.
NOTE: The data set WORK.TAXADJRET has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              1951.46k
      OS Memory           25344.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1500  Switch Count  0
      

4900  data TaxAdjRet; set TaxAdjRet;
4901  label TaxAdjRet = 'TaxAdjRet';
4902  

NOTE: There were 3326 observations read from the data set WORK.TAXADJRET.
NOTE: The data set WORK.TAXADJRET has 3326 observations and 406 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              1951.40k
      OS Memory           25344.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1501  Switch Count  0
      

4903  data TaxAdjRet1; set TaxAdjRet;
4904  keep Ticker Year TaxReportDate TaxAdjRet;
4905  

NOTE: There were 3326 observations read from the data set WORK.TAXADJRET.
NOTE: The data set WORK.TAXADJRET1 has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              1364.25k
      OS Memory           24828.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1502  Switch Count  0
      

4906  data turkey.taxadjret; set taxadjret1;
4907  
4908  run;

NOTE: There were 3326 observations read from the data set WORK.TAXADJRET1.
NOTE: The data set TURKEY.TAXADJRET has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              631.50k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1503  Switch Count  0
      

4909  
4910  *rename market adj ret on tax adj ret date;
4911  data taxadjret; set turkey.taxadjret;

NOTE: There were 3326 observations read from the data set TURKEY.TAXADJRET.
NOTE: The data set WORK.TAXADJRET has 3326 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              631.62k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1504  Switch Count  0
      

4912    proc sql;
4913          create table sample as select a.*, b.TaxAdjRet
4914          from sample as a left outer join taxadjret as b
4915          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 36 columns.

4916      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              5735.65k
      OS Memory           29436.00k
      Timestamp           08/25/2026 09:48:21 AM
      Step Count                        1505  Switch Count  0
      

4917  
4918  run;
4919  
4920  * bring in book date date market adjusted returns;
4921  proc import datafile="&filepath\BookEventMarketAdjRet.xlsx"
4922      out=BookAdjRet
4923      dbms=xlsx
4924      replace;
4925      getnames = yes;
4926  Run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 29677 observations and 805 variables.
NOTE: WORK.BOOKADJRET data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           3:11.26
      user cpu time       3:07.36
      system cpu time     2.64 seconds
      memory              6253.31k
      OS Memory           28744.00k
      Timestamp           08/25/2026 09:51:32 AM
      Step Count                        1506  Switch Count  0
      

4927  
4928  data BookAdjRet1; set BookAdjRet;
4929  if Quarter ne 4 then delete;
4930  
4931  *rename book adjusted date returns;

NOTE: There were 29677 observations read from the data set WORK.BOOKADJRET.
NOTE: The data set WORK.BOOKADJRET1 has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.22 seconds
      user cpu time       0.07 seconds
      system cpu time     0.14 seconds
      memory              2775.06k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1507  Switch Count  0
      

4932  data BookAdjRet1; set BookAdjRet1;
4933  rename D401 = BookAdjRet;
4934  

NOTE: There were 7754 observations read from the data set WORK.BOOKADJRET1.
NOTE: The data set WORK.BOOKADJRET1 has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      user cpu time       0.01 seconds
      system cpu time     0.06 seconds
      memory              2772.37k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1508  Switch Count  0
      

4935  data BookAdjRet1; set BookAdjRet1;
4936  label BookAdjRet = 'BookAdjRet';
4937  

NOTE: There were 7754 observations read from the data set WORK.BOOKADJRET1.
NOTE: The data set WORK.BOOKADJRET1 has 7754 observations and 805 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      user cpu time       0.01 seconds
      system cpu time     0.06 seconds
      memory              2772.37k
      OS Memory           25588.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1509  Switch Count  0
      

4938  data BookAdjRet2; set BookAdjRet1;
4939  keep Ticker Quarter Year BookAdjRet;
4940  

NOTE: There were 7754 observations read from the data set WORK.BOOKADJRET1.
NOTE: The data set WORK.BOOKADJRET2 has 7754 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.20 seconds
      user cpu time       0.00 seconds
      system cpu time     0.09 seconds
      memory              2004.71k
      OS Memory           25080.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1510  Switch Count  0
      

4941  data turkey.bookadjret; set bookadjret2;
4942  
4943  run;

NOTE: There were 7754 observations read from the data set WORK.BOOKADJRET2.
NOTE: The data set TURKEY.BOOKADJRET has 7754 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              628.50k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1511  Switch Count  0
      

4944  
4945  data bookadjret; set turkey.bookadjret;

NOTE: There were 7754 observations read from the data set TURKEY.BOOKADJRET.
NOTE: The data set WORK.BOOKADJRET has 7754 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              628.62k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1512  Switch Count  0
      

4946    proc sql;
4947          create table sample as select a.*, b.BookAdjRet
4948          from sample as a left outer join bookadjret as b
4949          on a.Ticker = b.Ticker and a.Year = b.Year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 11327 rows and 37 columns.

4950      quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              5734.81k
      OS Memory           29436.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1513  Switch Count  0
      

4951  
4952  run;
4953  
4954  *bring in current assets and current liabilities;
4955  data curatl; set turkey.curratl;
4956  

NOTE: There were 10200 observations read from the data set TURKEY.CURRATL.
NOTE: The data set WORK.CURATL has 10200 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              630.56k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1514  Switch Count  0
      

4957  proc sql;
4958  create table sample as select a.*, b.BsCa, b.BsCl
4959  from sample as a left outer join curatl as b
4960  on a.ticker = b.ticker and a.year = b.year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 11327 rows and 39 columns.

4961  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.03 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              13925.84k
      OS Memory           35984.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1515  Switch Count  0
      

4962  
4963  data sample; set sample;
4964  act = BsCa;
4965  lct = BsCL;
4966  
4967  
4968  *bring in compustat global variables - downloaded direclty from WRDS;

NOTE: There were 11327 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 11327 observations and 41 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              739.84k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1516  Switch Count  0
      

4969  data globalvars; set turkey.linkedtocomp;
4970  

NOTE: There were 4165 observations read from the data set TURKEY.LINKEDTOCOMP.
NOTE: The data set WORK.GLOBALVARS has 4165 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              648.59k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1517  Switch Count  0
      

4971  proc sql;
4972  create table sample as select *
4973  from sample as a left outer join globalvars as b
4974  on a.ticker = b.ticker and a.year = b.year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
WARNING: Variable ticker already exists on file WORK.SAMPLE.
WARNING: Variable Year already exists on file WORK.SAMPLE.
NOTE: Table WORK.SAMPLE created, with 11327 rows and 57 columns.

4975  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.06 seconds
      user cpu time       0.01 seconds
      system cpu time     0.04 seconds
      memory              20853.40k
      OS Memory           42812.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1518  Switch Count  0
      

4976  
4977  proc sort data = sample nodupkey; by ticker year;
4978  
4979  run;

NOTE: There were 11327 observations read from the data set WORK.SAMPLE.
NOTE: 1127 observations with duplicate key values were deleted.
NOTE: The data set WORK.SAMPLE has 10200 observations and 57 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.02 seconds
      user cpu time       0.00 seconds
      system cpu time     0.03 seconds
      memory              8260.18k
      OS Memory           31772.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1519  Switch Count  0
      

4980  
4981  *Tax expense variables;
4982  
4983  Data taxexpense; set turkey.taxexpensesample;
4984  

NOTE: There were 1585 observations read from the data set TURKEY.TAXEXPENSESAMPLE.
NOTE: The data set WORK.TAXEXPENSE has 1585 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              557.40k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1520  Switch Count  0
      

4985  data sample; set sample;
4986  drop booktxc booktxd booktxt;
4987  

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 54 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              777.00k
      OS Memory           24312.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1521  Switch Count  0
      

4988  proc sql;
4989  create table sample as select *
4990  from sample as a left outer join taxexpense as b
4991  on a.ticker = b.ticker and a.year = b.year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
WARNING: Variable ticker already exists on file WORK.SAMPLE.
WARNING: Variable Year already exists on file WORK.SAMPLE.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 57 columns.

4992  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.04 seconds
      user cpu time       0.00 seconds
      system cpu time     0.04 seconds
      memory              20568.84k
      OS Memory           42808.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1522  Switch Count  0
      

4993  
4994  proc means data = sample n mean; var booktxc booktxd booktxt;
4995  
4996  *modify variables to match typical compustat presentaion;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.04 seconds
      user cpu time       0.01 seconds
      system cpu time     0.01 seconds
      memory              7803.37k
      OS Memory           30220.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1523  Switch Count  0
      

4997  data sample; set sample;
4998  booktxc = booktxc *-1;
4999  booktxd = booktxd *-1;
5000  booktxt = booktxt * -1;
5001  
5002  
5003  *Manually collected capx;

NOTE: Missing values were generated as a result of performing an operation on missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      8630 at 4998:19   8636 at 4999:19   8615 at 5000:19   
NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 57 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              785.12k
      OS Memory           25080.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1524  Switch Count  0
      

5004   proc import datafile="C...\AdditionalCAPX.xlsx"
5005          out=addlcapx dbms=xlsx replace;
5006          getnames = yes;
5007      run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 53 observations and 7 variables.
NOTE: WORK.ADDLCAPX data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              3083.28k
      OS Memory           27464.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1525  Switch Count  0
      

5008  
5009  data turkey.addlcapx; set addlcapx;
5010  
5011  run;

NOTE: There were 53 observations read from the data set WORK.ADDLCAPX.
NOTE: The data set TURKEY.ADDLCAPX has 53 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              562.43k
      OS Memory           25080.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1526  Switch Count  0
      

5012  
5013  
5014  data addlcapx; set turkey.addlcapx;
5015  *in the previous sample construction I brough this in later already adjusted to millions, this should fix;
5016  capxfinalkap = capxfinalkap * 1000000;   * re-scale to raw TL so /1M conversion below gives correct millions;
5017  

NOTE: Missing values were generated as a result of performing an operation on missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      36 at 5016:29   
NOTE: There were 53 observations read from the data set TURKEY.ADDLCAPX.
NOTE: The data set WORK.ADDLCAPX has 53 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              562.84k
      OS Memory           25080.00k
      Timestamp           08/25/2026 09:51:33 AM
      Step Count                        1527  Switch Count  0
      

5018  proc sql;
5019  create table sample as select *
5020  from sample a left outer join addlcapx as b
5021  on a.ticker = b.ticker and a.year = b.year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
WARNING: Variable ticker already exists on file WORK.SAMPLE.
WARNING: Variable industry already exists on file WORK.SAMPLE.
WARNING: Variable year already exists on file WORK.SAMPLE.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 61 columns.

5022  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.04 seconds
      user cpu time       0.04 seconds
      system cpu time     0.00 seconds
      memory              20585.96k
      OS Memory           44092.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1528  Switch Count  0
      

5023  
5024  run;
5025  
5026  data sample; set sample;
5027  if capxfinalkap ne . then capxfinal = capxfinalkap;
5028  

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 61 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              791.40k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1529  Switch Count  0
      

5029  data sample; set sample;
5030  drop capxfinalkap capxkap units;
5031  
5032  *Additional hand-collected variables for years 2003-2008;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 58 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              788.90k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1530  Switch Count  0
      

5033  data prevariables; set turkey.presample;
5034  

NOTE: There were 655 observations read from the data set TURKEY.PRESAMPLE.
NOTE: The data set WORK.PREVARIABLES has 655 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              561.28k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1531  Switch Count  0
      

5035  proc sql;
5036  create table sample as select a.*, b.presample, b.capxfinalpre, b.cfopre, b.booktxcpre, b.booktxtpre, b.booktxdpre
5037  from sample as a left outer join prevariables as b
5038  on a.ticker=b.ticker and a.year = b.year;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 64 columns.

5039  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.04 seconds
      user cpu time       0.04 seconds
      system cpu time     0.04 seconds
      memory              20589.40k
      OS Memory           44092.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1532  Switch Count  0
      

5040  
5041  *have to adjust back to actual because they were collected as millions;
5042  data sample; set sample;
5043  if presample = 1 then capxfinal = capxfinalpre * 1000000;
5044  if presample = 1 then cfo = cfopre * 1000000;
5045  if presample = 1 then bookTXC = booktxcpre * 1000000;
5046  if presample = 1 then booktxt = booktxtpre * 1000000;
5047  if presample = 1 then booktxd = booktxdpre * 1000000;
5048  

NOTE: Missing values were generated as a result of performing an operation on missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      30 at 5043:48   1 at 5044:36    34 at 5045:44   34 at 5047:44   
NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 64 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              802.81k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1533  Switch Count  0
      

5049  proc sort data = sample; by year;
5050  

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 64 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              8255.03k
      OS Memory           33052.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1534  Switch Count  0
      

5051  proc means data = sample; by year; var capxfinal cfo booktxc booktxt booktxd;
5052  
5053  
5054  run;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.04 seconds
      user cpu time       0.03 seconds
      system cpu time     0.01 seconds
      memory              1806.81k
      OS Memory           26620.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1535  Switch Count  0
      

5055  
5056  proc means data = sample; var capxfinal;
5057  
5058  run;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.02 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              7333.53k
      OS Memory           32292.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1536  Switch Count  0
      

5059  
5060  
5061  run;
5062  
5063  *merge in inflation factors;
5064  proc import datafile="...\MonthlyInflationDataforSAS.xlsx"
5065      out=MonthlyInflation
5066      dbms=xlsx
5067      replace;
5068      getnames = yes;
5069  Run;

NOTE: The import data set has 834 observations and 2 variables.
NOTE: WORK.MONTHLYINFLATION data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.03 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              3090.71k
      OS Memory           27976.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1537  Switch Count  0
      

5070  
5071  data MonthlyInflation1;
5072      set MonthlyInflation;
5073  
5074      * Extract month and year;
5075      infmonth = month(inflationdate);
5076      infyear = year(inflationdate);
5077  run;

NOTE: There were 834 observations read from the data set WORK.MONTHLYINFLATION.
NOTE: The data set WORK.MONTHLYINFLATION1 has 834 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              560.84k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1538  Switch Count  0
      

5078  
5079  data turkey.monthlyinflation; set monthlyinflation1;
5080  
5081  
5082  *merge in CPI factor the book report date month;

NOTE: There were 834 observations read from the data set WORK.MONTHLYINFLATION1.
NOTE: The data set TURKEY.MONTHLYINFLATION has 834 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              554.78k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1539  Switch Count  0
      

5083  data monthlyinflation; set turkey.monthlyinflation;
5084  

NOTE: There were 834 observations read from the data set TURKEY.MONTHLYINFLATION.
NOTE: The data set WORK.MONTHLYINFLATION has 834 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              556.56k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1540  Switch Count  0
      

5085  data sample;
5086      set sample;
5087      * Convert BooKReportDate from character to SAS date;
5088      BookDateVar = input(BooKReportDate, yymmdd10.);
5089  
5090      * Apply date format to DateVar;
5091      format BookDateVar date9.;
5092  
5093      * Extract month and day;
5094      BookMonth = month(BookDateVar);
5095      Bookyear = year(BookDateVar);
5096  run;

NOTE: Missing values were generated as a result of performing an operation on missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      3750 at 5094:17   3750 at 5095:16   
NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 67 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              811.96k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1541  Switch Count  0
      

5097  
5098  proc sql;
5099  create table sample as select a.*, b.inflationdate, b.turkeycpi
5100  from sample as a left outer join monthlyinflation as b
5101  on a.bookmonth = b.infmonth and a.bookyear = b.infyear;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem.
NOTE: Table WORK.SAMPLE created, with 10200 rows and 69 columns.

5102  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.03 seconds
      user cpu time       0.01 seconds
      system cpu time     0.03 seconds
      memory              20607.84k
      OS Memory           44092.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1542  Switch Count  0
      

5103  
5104  
5105  data sample; set sample;
5106  label equity = 'Equity';
5107  label assets = 'Assets';
5108  
5109  run;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set WORK.SAMPLE has 10200 observations and 69 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.01 seconds
      system cpu time     0.00 seconds
      memory              812.81k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1543  Switch Count  0
      

5110  
5111  data turkey.mergeddataset; set sample;
5112  run;

NOTE: There were 10200 observations read from the data set WORK.SAMPLE.
NOTE: The data set TURKEY.MERGEDDATASET has 10200 observations and 69 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              813.12k
      OS Memory           25592.00k
      Timestamp           08/25/2026 09:51:34 AM
      Step Count                        1544  Switch Count  0
      